/*
 Navicat Premium Data Transfer

 Source Server         : 10.200.9.224.show.mysql
 Source Server Type    : MySQL
 Source Server Version : 80016
 Source Host           : 10.200.9.224:3306
 Source Schema         : demo_school

 Target Server Type    : MySQL
 Target Server Version : 80016
 File Encoding         : 65001

 Date: 02/02/2021 10:10:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dic_school_type
-- ----------------------------
DROP TABLE IF EXISTS `dic_school_type`;
CREATE TABLE `dic_school_type` (
  `code` varchar(100) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of dic_school_type
-- ----------------------------
BEGIN;
INSERT INTO `dic_school_type` VALUES ('school_type_001', '2021-01-28 20:42:20', '小学');
INSERT INTO `dic_school_type` VALUES ('school_type_002', '2021-01-28 20:42:20', '高中');
COMMIT;

-- ----------------------------
-- Table structure for school
-- ----------------------------
DROP TABLE IF EXISTS `school`;
CREATE TABLE `school` (
  `id` varchar(50) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `school_name` varchar(255) DEFAULT NULL,
  `school_type_id` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of school
-- ----------------------------
BEGIN;
INSERT INTO `school` VALUES ('8b7c66129a85e4cdfed21f32fab9eab2', '2021-01-28 20:48:21', '向阳一中', 'school_type_002');
INSERT INTO `school` VALUES ('9437f68f2b762c98e19f5e35c3819e53', '2021-01-28 20:48:21', '景山小学', 'school_type_001');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
